package com.ruoyi.report_sj.mapper;

import com.ruoyi.report_sj.domain.ReportSjnjsjBaDetail;
import com.ruoyi.report_sj.domain.vo.ReportSjnjsjBaDetailVo;
import com.ruoyi.common.core.mapper.BaseMapperPlus;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 砂浆凝结时间试验检测记录详情Mapper接口
 *
 * @author zyb
 * @date 2024-05-29
 */
public interface ReportSjnjsjBaDetailMapper extends BaseMapperPlus<ReportSjnjsjBaDetailMapper, ReportSjnjsjBaDetail, ReportSjnjsjBaDetailVo> {

    @Select("select * from report_sjnjsj_ba_detail where excel_id = #{excelId} and del_flag = 0")
    List<ReportSjnjsjBaDetail> selectListByExcelId(Long excelId);

    @Delete("delete from report_sjnjsj_ba_detail where excel_id = #{excelId}")
    void deleteByExcelId(Long excelId);

}
